Home
ร้านอาหาร
คอมเม้นต์ร้านทั้งหมด
แชร์ชวนชิม
ผลการค้นหา: "[ร้านอาหารทั้งหมด]"
แถว "BTS-ชิดลม"
[-]
Search Filters
แถว
- BTS-ชิดลม
รวมสถานีใกล้เคียงด้วย
อาหาร/ร้าน
ประเภทอาหาร (Cuisines)
more...
ประเภทตัวร้าน (Restaurants)
more...
Features ของร้าน
more...
ช่วงราคาmore...
Loading map...
| Nr | Query | Error | Affected | Num. rows | Took (ms) |
|---|---|---|---|---|---|
| 1 | SHOW FULL COLUMNS FROM `rests_comments` | 27 | 27 | 26 | |
| 2 | SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci'; | 1 | 1 | 3 | |
| 3 | SHOW FULL COLUMNS FROM `nonmembers` | 3 | 3 | 18 | |
| 4 | SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'latin1_swedish_ci'; | 1 | 1 | 2 | |
| 5 | SHOW FULL COLUMNS FROM `rests_pics` | 22 | 22 | 18 | |
| 6 | SHOW FULL COLUMNS FROM `rest_pic_types` | 6 | 6 | 16 | |
| 7 | SHOW FULL COLUMNS FROM `admin_tmp_pics` | 12 | 12 | 36 | |
| 8 | SHOW FULL COLUMNS FROM `blds_pics` | 19 | 19 | 36 | |
| 9 | SHOW FULL COLUMNS FROM `visits` | 7 | 7 | 46 | |
| 10 | SHOW FULL COLUMNS FROM `unique_visitors` | 5 | 5 | 44 | |
| 11 | SHOW FULL COLUMNS FROM `searches` | 10 | 10 | 23 | |
| 12 | SHOW FULL COLUMNS FROM `rests_comments_likes` | 5 | 5 | 32 | |
| 13 | SHOW FULL COLUMNS FROM `rests_pics_likes` | 5 | 5 | 24 | |
| 14 | SHOW FULL COLUMNS FROM `blds_pics_likes` | 5 | 5 | 28 | |
| 15 | SHOW FULL COLUMNS FROM `external_reviews_likes` | 5 | 5 | 13 | |
| 16 | SHOW FULL COLUMNS FROM `external_reviews` | 23 | 23 | 36 | |
| 17 | SHOW FULL COLUMNS FROM `rest_chains` | 35 | 35 | 45 | |
| 18 | SHOW FULL COLUMNS FROM `reported_pics` | 16 | 16 | 25 | |
| 19 | SELECT `Setting`.`id`, `Setting`.`key`, `Setting`.`value`, `Setting`.`description` FROM `settings` AS `Setting` WHERE 1 = 1 | 2 | 2 | 0 | |
| 20 | SELECT `Bts`.`id`, `Bts`.`isBtsOrMrt`, `Bts`.`line`, `Bts`.`station_no`, `Bts`.`station_code`, `Bts`.`nameTh`, `Bts`.`nameEn`, `Bts`.`addr`, `Bts`.`lat`, `Bts`.`lng`, `Bts`.`num_rests`, `Bts`.`num_blds`, `Bts`.`exit1_lat`, `Bts`.`exit1_long`, `Bts`.`exit2_lat`, `Bts`.`exit2_long`, `Bts`.`exit3_lat`, `Bts`.`exit3_long`, `Bts`.`exit4_lat`, `Bts`.`exit4_long`, `Bts`.`exit5_lat`, `Bts`.`exit5_long`, `Bts`.`exit6_lat`, `Bts`.`exit6_long`, `Bts`.`created`, `Bts`.`modified`, `Bts`.`nearby_bts1_id`, `Bts`.`nearby_bts2_id`, `Bts`.`nearby_bts3_id`, `Bts`.`nearby_mrt1_id`, `Bts`.`nearby_mrt2_id`, `Bts`.`nearby_mrt3_id`, `Bts`.`popular_ranking`, (CONCAT("BTS-", `Bts`.`nameTh`)) AS `Bts__full_nameTh`, (CONCAT("BTS-", `Bts`.`nameEn`)) AS `Bts__full_nameEn` FROM `btses` AS `Bts` WHERE ((`Bts`.`nameEn` LIKE '%Chit Lom%') OR (`Bts`.`nameTh` LIKE '%Chit Lom%')) LIMIT 1 | 1 | 1 | 1 | |
| 21 | SELECT `Bts`.`id`, `Bts`.`isBtsOrMrt`, `Bts`.`line`, `Bts`.`station_no`, `Bts`.`station_code`, `Bts`.`nameTh`, `Bts`.`nameEn`, `Bts`.`addr`, `Bts`.`lat`, `Bts`.`lng`, `Bts`.`num_rests`, `Bts`.`num_blds`, `Bts`.`exit1_lat`, `Bts`.`exit1_long`, `Bts`.`exit2_lat`, `Bts`.`exit2_long`, `Bts`.`exit3_lat`, `Bts`.`exit3_long`, `Bts`.`exit4_lat`, `Bts`.`exit4_long`, `Bts`.`exit5_lat`, `Bts`.`exit5_long`, `Bts`.`exit6_lat`, `Bts`.`exit6_long`, `Bts`.`created`, `Bts`.`modified`, `Bts`.`nearby_bts1_id`, `Bts`.`nearby_bts2_id`, `Bts`.`nearby_bts3_id`, `Bts`.`nearby_mrt1_id`, `Bts`.`nearby_mrt2_id`, `Bts`.`nearby_mrt3_id`, `Bts`.`popular_ranking`, (CONCAT("BTS-", `Bts`.`nameTh`)) AS `Bts__full_nameTh`, (CONCAT("BTS-", `Bts`.`nameEn`)) AS `Bts__full_nameEn`, `NearbyToBts1`.`id`, `NearbyToBts1`.`isBtsOrMrt`, `NearbyToBts1`.`line`, `NearbyToBts1`.`station_no`, `NearbyToBts1`.`station_code`, `NearbyToBts1`.`nameTh`, `NearbyToBts1`.`nameEn`, `NearbyToBts1`.`addr`, `NearbyToBts1`.`lat`, `NearbyToBts1`.`lng`, `NearbyToBts1`.`num_rests`, `NearbyToBts1`.`num_blds`, `NearbyToBts1`.`exit1_lat`, `NearbyToBts1`.`exit1_long`, `NearbyToBts1`.`exit2_lat`, `NearbyToBts1`.`exit2_long`, `NearbyToBts1`.`exit3_lat`, `NearbyToBts1`.`exit3_long`, `NearbyToBts1`.`exit4_lat`, `NearbyToBts1`.`exit4_long`, `NearbyToBts1`.`exit5_lat`, `NearbyToBts1`.`exit5_long`, `NearbyToBts1`.`exit6_lat`, `NearbyToBts1`.`exit6_long`, `NearbyToBts1`.`created`, `NearbyToBts1`.`modified`, `NearbyToBts1`.`nearby_bts1_id`, `NearbyToBts1`.`nearby_bts2_id`, `NearbyToBts1`.`nearby_bts3_id`, `NearbyToBts1`.`nearby_mrt1_id`, `NearbyToBts1`.`nearby_mrt2_id`, `NearbyToBts1`.`nearby_mrt3_id`, `NearbyToBts1`.`popular_ranking`, (CONCAT("BTS-", `NearbyToBts1`.`nameTh`)) AS `NearbyToBts1__full_nameTh`, (CONCAT("BTS-", `NearbyToBts1`.`nameEn`)) AS `NearbyToBts1__full_nameEn`, `NearbyToBts2`.`id`, `NearbyToBts2`.`isBtsOrMrt`, `NearbyToBts2`.`line`, `NearbyToBts2`.`station_no`, `NearbyToBts2`.`station_code`, `NearbyToBts2`.`nameTh`, `NearbyToBts2`.`nameEn`, `NearbyToBts2`.`addr`, `NearbyToBts2`.`lat`, `NearbyToBts2`.`lng`, `NearbyToBts2`.`num_rests`, `NearbyToBts2`.`num_blds`, `NearbyToBts2`.`exit1_lat`, `NearbyToBts2`.`exit1_long`, `NearbyToBts2`.`exit2_lat`, `NearbyToBts2`.`exit2_long`, `NearbyToBts2`.`exit3_lat`, `NearbyToBts2`.`exit3_long`, `NearbyToBts2`.`exit4_lat`, `NearbyToBts2`.`exit4_long`, `NearbyToBts2`.`exit5_lat`, `NearbyToBts2`.`exit5_long`, `NearbyToBts2`.`exit6_lat`, `NearbyToBts2`.`exit6_long`, `NearbyToBts2`.`created`, `NearbyToBts2`.`modified`, `NearbyToBts2`.`nearby_bts1_id`, `NearbyToBts2`.`nearby_bts2_id`, `NearbyToBts2`.`nearby_bts3_id`, `NearbyToBts2`.`nearby_mrt1_id`, `NearbyToBts2`.`nearby_mrt2_id`, `NearbyToBts2`.`nearby_mrt3_id`, `NearbyToBts2`.`popular_ranking`, (CONCAT("BTS-", `NearbyToBts2`.`nameTh`)) AS `NearbyToBts2__full_nameTh`, (CONCAT("BTS-", `NearbyToBts2`.`nameEn`)) AS `NearbyToBts2__full_nameEn`, `NearbyToBts3`.`id`, `NearbyToBts3`.`isBtsOrMrt`, `NearbyToBts3`.`line`, `NearbyToBts3`.`station_no`, `NearbyToBts3`.`station_code`, `NearbyToBts3`.`nameTh`, `NearbyToBts3`.`nameEn`, `NearbyToBts3`.`addr`, `NearbyToBts3`.`lat`, `NearbyToBts3`.`lng`, `NearbyToBts3`.`num_rests`, `NearbyToBts3`.`num_blds`, `NearbyToBts3`.`exit1_lat`, `NearbyToBts3`.`exit1_long`, `NearbyToBts3`.`exit2_lat`, `NearbyToBts3`.`exit2_long`, `NearbyToBts3`.`exit3_lat`, `NearbyToBts3`.`exit3_long`, `NearbyToBts3`.`exit4_lat`, `NearbyToBts3`.`exit4_long`, `NearbyToBts3`.`exit5_lat`, `NearbyToBts3`.`exit5_long`, `NearbyToBts3`.`exit6_lat`, `NearbyToBts3`.`exit6_long`, `NearbyToBts3`.`created`, `NearbyToBts3`.`modified`, `NearbyToBts3`.`nearby_bts1_id`, `NearbyToBts3`.`nearby_bts2_id`, `NearbyToBts3`.`nearby_bts3_id`, `NearbyToBts3`.`nearby_mrt1_id`, `NearbyToBts3`.`nearby_mrt2_id`, `NearbyToBts3`.`nearby_mrt3_id`, `NearbyToBts3`.`popular_ranking`, (CONCAT("BTS-", `NearbyToBts3`.`nameTh`)) AS `NearbyToBts3__full_nameTh`, (CONCAT("BTS-", `NearbyToBts3`.`nameEn`)) AS `NearbyToBts3__full_nameEn` FROM `btses` AS `Bts` LEFT JOIN `btses` AS `NearbyToBts1` ON (`Bts`.`nearby_bts1_id` = `NearbyToBts1`.`id`) LEFT JOIN `btses` AS `NearbyToBts2` ON (`Bts`.`nearby_bts2_id` = `NearbyToBts2`.`id`) LEFT JOIN `btses` AS `NearbyToBts3` ON (`Bts`.`nearby_bts3_id` = `NearbyToBts3`.`id`) WHERE `Bts`.`id` = 9 LIMIT 1 | 1 | 1 | 4 | |
| 22 | SELECT `Bts`.`id`, `Bts`.`isBtsOrMrt`, `Bts`.`line`, `Bts`.`station_no`, `Bts`.`station_code`, `Bts`.`nameTh`, `Bts`.`nameEn`, `Bts`.`addr`, `Bts`.`lat`, `Bts`.`lng`, `Bts`.`num_rests`, `Bts`.`num_blds`, `Bts`.`exit1_lat`, `Bts`.`exit1_long`, `Bts`.`exit2_lat`, `Bts`.`exit2_long`, `Bts`.`exit3_lat`, `Bts`.`exit3_long`, `Bts`.`exit4_lat`, `Bts`.`exit4_long`, `Bts`.`exit5_lat`, `Bts`.`exit5_long`, `Bts`.`exit6_lat`, `Bts`.`exit6_long`, `Bts`.`created`, `Bts`.`modified`, `Bts`.`nearby_bts1_id`, `Bts`.`nearby_bts2_id`, `Bts`.`nearby_bts3_id`, `Bts`.`nearby_mrt1_id`, `Bts`.`nearby_mrt2_id`, `Bts`.`nearby_mrt3_id`, `Bts`.`popular_ranking`, (CONCAT("BTS-", `Bts`.`nameTh`)) AS `Bts__full_nameTh`, (CONCAT("BTS-", `Bts`.`nameEn`)) AS `Bts__full_nameEn`, `NearbyToMrt1`.`id`, `NearbyToMrt1`.`line`, `NearbyToMrt1`.`station_no`, `NearbyToMrt1`.`station_code`, `NearbyToMrt1`.`nameTh`, `NearbyToMrt1`.`nameEn`, `NearbyToMrt1`.`addr`, `NearbyToMrt1`.`lat`, `NearbyToMrt1`.`lng`, `NearbyToMrt1`.`num_rests`, `NearbyToMrt1`.`num_blds`, `NearbyToMrt1`.`exit1_lat`, `NearbyToMrt1`.`exit1_long`, `NearbyToMrt1`.`exit2_lat`, `NearbyToMrt1`.`exit2_long`, `NearbyToMrt1`.`exit3_lat`, `NearbyToMrt1`.`exit3_long`, `NearbyToMrt1`.`exit4_lat`, `NearbyToMrt1`.`exit4_long`, `NearbyToMrt1`.`exit5_lat`, `NearbyToMrt1`.`exit5_long`, `NearbyToMrt1`.`exit6_lat`, `NearbyToMrt1`.`exit6_long`, `NearbyToMrt1`.`created`, `NearbyToMrt1`.`modified`, `NearbyToMrt1`.`nearby_bts1_id`, `NearbyToMrt1`.`nearby_bts2_id`, `NearbyToMrt1`.`nearby_bts3_id`, `NearbyToMrt1`.`nearby_mrt1_id`, `NearbyToMrt1`.`nearby_mrt2_id`, `NearbyToMrt1`.`nearby_mrt3_id`, `NearbyToMrt1`.`popular_ranking`, (CONCAT("MRT-", `NearbyToMrt1`.`nameTh`)) AS `NearbyToMrt1__full_nameTh`, (CONCAT("MRT-", `NearbyToMrt1`.`nameEn`)) AS `NearbyToMrt1__full_nameEn`, `NearbyToMrt2`.`id`, `NearbyToMrt2`.`line`, `NearbyToMrt2`.`station_no`, `NearbyToMrt2`.`station_code`, `NearbyToMrt2`.`nameTh`, `NearbyToMrt2`.`nameEn`, `NearbyToMrt2`.`addr`, `NearbyToMrt2`.`lat`, `NearbyToMrt2`.`lng`, `NearbyToMrt2`.`num_rests`, `NearbyToMrt2`.`num_blds`, `NearbyToMrt2`.`exit1_lat`, `NearbyToMrt2`.`exit1_long`, `NearbyToMrt2`.`exit2_lat`, `NearbyToMrt2`.`exit2_long`, `NearbyToMrt2`.`exit3_lat`, `NearbyToMrt2`.`exit3_long`, `NearbyToMrt2`.`exit4_lat`, `NearbyToMrt2`.`exit4_long`, `NearbyToMrt2`.`exit5_lat`, `NearbyToMrt2`.`exit5_long`, `NearbyToMrt2`.`exit6_lat`, `NearbyToMrt2`.`exit6_long`, `NearbyToMrt2`.`created`, `NearbyToMrt2`.`modified`, `NearbyToMrt2`.`nearby_bts1_id`, `NearbyToMrt2`.`nearby_bts2_id`, `NearbyToMrt2`.`nearby_bts3_id`, `NearbyToMrt2`.`nearby_mrt1_id`, `NearbyToMrt2`.`nearby_mrt2_id`, `NearbyToMrt2`.`nearby_mrt3_id`, `NearbyToMrt2`.`popular_ranking`, (CONCAT("MRT-", `NearbyToMrt2`.`nameTh`)) AS `NearbyToMrt2__full_nameTh`, (CONCAT("MRT-", `NearbyToMrt2`.`nameEn`)) AS `NearbyToMrt2__full_nameEn`, `NearbyToMrt3`.`id`, `NearbyToMrt3`.`line`, `NearbyToMrt3`.`station_no`, `NearbyToMrt3`.`station_code`, `NearbyToMrt3`.`nameTh`, `NearbyToMrt3`.`nameEn`, `NearbyToMrt3`.`addr`, `NearbyToMrt3`.`lat`, `NearbyToMrt3`.`lng`, `NearbyToMrt3`.`num_rests`, `NearbyToMrt3`.`num_blds`, `NearbyToMrt3`.`exit1_lat`, `NearbyToMrt3`.`exit1_long`, `NearbyToMrt3`.`exit2_lat`, `NearbyToMrt3`.`exit2_long`, `NearbyToMrt3`.`exit3_lat`, `NearbyToMrt3`.`exit3_long`, `NearbyToMrt3`.`exit4_lat`, `NearbyToMrt3`.`exit4_long`, `NearbyToMrt3`.`exit5_lat`, `NearbyToMrt3`.`exit5_long`, `NearbyToMrt3`.`exit6_lat`, `NearbyToMrt3`.`exit6_long`, `NearbyToMrt3`.`created`, `NearbyToMrt3`.`modified`, `NearbyToMrt3`.`nearby_bts1_id`, `NearbyToMrt3`.`nearby_bts2_id`, `NearbyToMrt3`.`nearby_bts3_id`, `NearbyToMrt3`.`nearby_mrt1_id`, `NearbyToMrt3`.`nearby_mrt2_id`, `NearbyToMrt3`.`nearby_mrt3_id`, `NearbyToMrt3`.`popular_ranking`, (CONCAT("MRT-", `NearbyToMrt3`.`nameTh`)) AS `NearbyToMrt3__full_nameTh`, (CONCAT("MRT-", `NearbyToMrt3`.`nameEn`)) AS `NearbyToMrt3__full_nameEn` FROM `btses` AS `Bts` LEFT JOIN `mrts` AS `NearbyToMrt1` ON (`Bts`.`nearby_mrt1_id` = `NearbyToMrt1`.`id`) LEFT JOIN `mrts` AS `NearbyToMrt2` ON (`Bts`.`nearby_mrt2_id` = `NearbyToMrt2`.`id`) LEFT JOIN `mrts` AS `NearbyToMrt3` ON (`Bts`.`nearby_mrt3_id` = `NearbyToMrt3`.`id`) WHERE `Bts`.`id` = 9 LIMIT 1 | 1 | 1 | 3 | |
| 23 | SELECT `CuisineType`.`id`, `CuisineType`.`nameEn`, `CuisineType`.`nameTh`, `CuisineType`.`level`, `CuisineType`.`parent_id`, `CuisineType`.`popular_ranking`, `CuisineType`.`show_in_filter`, `CuisineType`.`created`, `CuisineType`.`modified`, `CuisineType`.`preferred_order` FROM `cuisine_types` AS `CuisineType` WHERE `CuisineType`.`show_in_filter` = 1 ORDER BY `CuisineType`.`level` ASC, ABS(`preferred_order`) ASC, CONVERT(`CuisineType`.`nameTh` USING tis620) ASC | 74 | 74 | 0 | |
| 24 | SELECT `CuisineType`.`id`, `CuisineType`.`nameEn`, `CuisineType`.`nameTh`, `CuisineType`.`level`, `CuisineType`.`parent_id`, `CuisineType`.`popular_ranking`, `CuisineType`.`show_in_filter`, `CuisineType`.`created`, `CuisineType`.`modified`, `CuisineType`.`preferred_order` FROM `cuisine_types` AS `CuisineType` WHERE `CuisineType`.`popular_ranking` > 0 ORDER BY `CuisineType`.`popular_ranking` ASC LIMIT 6 | 6 | 6 | 0 | |
| 25 | SELECT `RestType`.`id`, `RestType`.`nameEn`, `RestType`.`nameTh`, `RestType`.`level`, `RestType`.`parent_id`, `RestType`.`created`, `RestType`.`modified`, `RestType`.`popular_ranking`, `RestType`.`show_in_filter`, `RestType`.`preferred_order` FROM `rest_types` AS `RestType` WHERE `RestType`.`popular_ranking` > 0 ORDER BY `RestType`.`popular_ranking` ASC LIMIT 6 | 5 | 5 | 0 | |
| 26 | SELECT `RestType`.`id`, `RestType`.`nameEn`, `RestType`.`nameTh`, `RestType`.`level`, `RestType`.`parent_id`, `RestType`.`created`, `RestType`.`modified`, `RestType`.`popular_ranking`, `RestType`.`show_in_filter`, `RestType`.`preferred_order` FROM `rest_types` AS `RestType` WHERE `RestType`.`show_in_filter` = 1 ORDER BY `RestType`.`level` ASC, ABS(`preferred_order`) ASC, CONVERT(`RestType`.`nameTh` USING tis620) ASC | 20 | 20 | 0 | |
| 27 | SELECT `RestFeature`.`id`, `RestFeature`.`nameEn`, `RestFeature`.`nameTh`, `RestFeature`.`level`, `RestFeature`.`parent_id`, `RestFeature`.`created`, `RestFeature`.`modified`, `RestFeature`.`popular_ranking`, `RestFeature`.`preferred_order`, `RestFeature`.`show_in_filter` FROM `rest_features` AS `RestFeature` WHERE `RestFeature`.`popular_ranking` > 0 ORDER BY `RestFeature`.`popular_ranking` ASC LIMIT 6 | 3 | 3 | 0 | |
| 28 | SELECT `RestFeature`.`id`, `RestFeature`.`nameEn`, `RestFeature`.`nameTh`, `RestFeature`.`level`, `RestFeature`.`parent_id`, `RestFeature`.`created`, `RestFeature`.`modified`, `RestFeature`.`popular_ranking`, `RestFeature`.`preferred_order`, `RestFeature`.`show_in_filter` FROM `rest_features` AS `RestFeature` WHERE `RestFeature`.`show_in_filter` = 1 ORDER BY `RestFeature`.`level` ASC, ABS(`preferred_order`) ASC, CONVERT(`RestFeature`.`nameTh` USING tis620) ASC | 27 | 27 | 0 | |
| 29 | SELECT `PriceRange`.`id`, `PriceRange`.`nameTh`, `PriceRange`.`nameEn`, `PriceRange`.`from`, `PriceRange`.`to`, `PriceRange`.`created`, `PriceRange`.`modified` FROM `price_ranges` AS `PriceRange` WHERE 1 = 1 ORDER BY `PriceRange`.`id` ASC | 9 | 9 | 0 |
